﻿CREATE TABLE [CoffeeShop].[OrderDetail] (
    [OrderDetailId]   INT            IDENTITY (1, 1) NOT NULL,
    [OrderId]         INT            NOT NULL,
    [ProductId]       INT            NOT NULL,
    [Price]           FLOAT          NOT NULL,
    [ReasonForDelete] NVARCHAR (MAX) NULL,
    [OrderStatusCode] NCHAR (10)     NOT NULL
);

